
A. The trigger is fired, a message is displayed, and the update is successful
B. The trigger is fired and a message is displayed, but the update is rolled back.
C. The trigger is not fired because the when clause should be used to specify the condition,
however, the update is successful.
D. The trigger is not fired because column names must be specified with the update event
to identify which columns must be changed to cause the trigger to fire, however, the update
is successful.
Answer: D
Which two statements are correct about PL/SQL package components? (Choose two)
A. A package must have both specification and body.
B. A package body can exist without the package specification.
C. A package specification can exist without the package body.
D. When a packaged public variable is called for the first time in a session, the entire
package is loaded into memory.
Answer: C,D
Which system events can be used to create triggers that fire both at database and schema
levels? (Choose all that apply)
A. AFTER LOGON
B. AFTER STARTUP
C. BEFORE SHUTDOWN
D. AFTER SERVERERROR
Answer: A,D
Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064
Question No : 11
Question No : 12
Oracle 1z0-144 : Practice Test
10
http://certkill.com